While the process of posting inventory transactions for multiple warehouses and standard inventory is the same, you need to be aware of the following when posting transactions for multiple warehouses:
Removing Warehouses
Once you remove a product's warehouse, you cannot post any outstanding, non-posted inventory transactions for that warehouse. If you post inventory transactions manually and remove a product's warehouse, all non-posted inventory transactions will be removed from the Post receipts window. However, non-posted inventory transactions will still display on the Enter and edit receipts and adjustments window (from Orders, select Enter and edit receipts and adjustments).
Inventory Transfers
Transferring inventory from one warehouse to another affects both product cost and inventory field values when a transfer is posted.
Cost of Goods Sold - Regardless of whether the Average or Standard Cost valuation method is selected when the Cost of Goods Sold option is enabled on the Inventory System Setup window, the following rule applies when posting inventory transfers:
The extended amount of the transferred product cannot exceed the current total cost of the From Warehouse.
If the extended amount of the transferred product exceeds the current total cost of the From Warehouse, then iMIS will perform the following calculations:
Field Recalculation
The following fields will be recalculated when transferring inventory from one warehouse to another:
Qty on Hand (Manage products window) will be reduced by the Quantity (Enter and edit receipts and adjustments window) transferred.
Total cost (Warehouses window) will be reduced by the Ext Amt (Enter and edit receipts and adjustments window) of the product transferred.
Avg/Std cost (Warehouses window) will be updated by dividing the Total cost (Warehouses window) by the Qty on Hand (Manage products window).
Qty on Hand (Manage products window) will be increased by the Quantity (Enter and edit receipts and adjustments window) transferred.
Total cost (Warehouses window) will be increased by the Ext Amt (Enter and edit receipts and adjustments window) of the product transferred.
Avg/Std cost (Warehouses window) will be updated by dividing the Total cost (Warehouses window) by the Qty on Hand (Manage products window).
10.6 Production Release. Updated 7/15/2005 2:14:04 PM
Copyright © by Advanced Solutions International, Inc.
All rights reserved.